package com.javaweb.admin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.javaweb.admin.entity.KdlStoredoc;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface KdlStoredocMapper extends BaseMapper<KdlStoredoc> {

    @Select("select distinct plant,plantname from kdl_storedoc order by plant")
    List<KdlStoredoc> getPlantList();

    @Select("select distinct bincode,bindesc from kdl_storedoc where plant=#{plant} order by bincode")
    List<KdlStoredoc> getBincodeList(String plant);

}
